Setup
Some notes: Where I thought the data was too jittery, I included a trendline that uses a rolling average and a trendline that shows each individual years of data.
Education : Bachelor Degree Attainment ages 25-64
Ranking
Trendline by ethnicity
It’s a bit tough to break down the data by race and include peer city information on the same graph, since that ends up with 12 lines to fit on the page. The third graph I included here tries to do that. The solid line represents Louisville, the dashed line represents our peer average, and the shaded area represents the 25th and 75th percentiles of our peers. The Bachelor degree version is very messy since the lines for black and hispanic are overlapping so much.
Map
Change
This will be a change graph for bachelor degree attainment by poverty status, though I’m still waiting on Nate to send me his code. I included some other graphs in the meantime.
Note the axes for these are different. Sorry about that.
Assoc Ranking
Assoc Trendline
Young adult degrees
Education pipeline
Still waiting on private school data
Jobs: median earnings
Ranking
Trendline by race
Map
## change: high wage jobsEarnings gap
Jobs by zip code
I removed some zip codes with very low population to avod skewing the numbers. I also removed downtown because it is so diffferent from everywhere else in the county: if it is included, the rest of the map is white.
Businesses per resident
Jobs per resident
Payroll per resident
Payroll per worker
Unemployment trendline by race
The survey size is too small to include Hispanic residents. I can get ahold of 3- or 5- year estimates, but it will take me a while. 